﻿CREATE PROCEDURE [dbo].[ETL_SP_GetSummary4DtSerCount]
AS
select SERT.Caption as TypeText, SERC.*
from ETL_DtSerType as SERT
	inner join (select COUNT(SER.Id) as [Count], SER.TypeId
		from ETL_DtSer as SER
		group by SER.TypeId) as SERC on SERC.TypeId = SERT.Id